1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's channels by remote control. 380 TVL of horizontal definition. Micro camera eas' at line 3
in:
[select count(p.products_id) as total FROM products p, products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 and ( pd.products_name LIKE '%bathspycamera.com 2.4Ghz Wireless Camera Kit Description:  2.4Ghz Wireless Camera Kit Features W208G4 Switch the receiver's channels by remote control. 380 TVL of horizontal definition. Micro camera easy for installation. 4 cameras exchangeble for watch. Receiver with 4 channesl exchangeble by auto %' OR p.products_model LIKE '%bathspycamera.com 2.4Ghz Wireless Camera Kit Description:  2.4Ghz Wireless Camera Kit Features W208G4 Switch the receiver's channels by remote control. 380 TVL of horizontal definition. Micro camera easy for installation. 4 cameras exchangeble for watch. Receiver with 4 channesl exchangeble by auto %') ]